package com.topisv.tms.repository.stock.outstorage;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.topisv.tms.entity.stock.oustorage.OutstorageBox;

/**
 * 出库箱_dao
 * @author ch
 *
 */
public abstract interface OutstorageBoxDao extends PagingAndSortingRepository<OutstorageBox, Long>, JpaSpecificationExecutor<OutstorageBox>
{

	@Query("select t from OutstorageBox t where t.boxCode=?")
	OutstorageBox loadByBoxCode(String boxCode);

	@Query("select t from OutstorageBox t where t.billCode=?")
	List<OutstorageBox> loadByBillCode(String billCode);


}